USE [MVCProjectBlog]
GO

INSERT INTO [dbo].[User]
           ([Deleted]
		   ,[Created]
           ,[Email]
           ,[Name]
           ,[Country]
           ,[Password])
     VALUES 
	 (0, '2014-04-25 20:50:00.000', 'carlover123@live.com', 'Duncan', 'Estonia', '123'),
	 (0, '2014-04-25 20:50:00.000', 'bigbootylover123@yahoo.com', 'Jahmal', 'Brazil', '123'),
	 (0, '2014-04-25 20:50:00.000', 'mvctester@mysite.com', 'Pierce', 'Ukraine', '123')
GO

USE [MVCProjectBlog]
GO

INSERT INTO [dbo].[Blog]
           ([Deleted]
		   ,[Created]
           ,[BlogName]
           ,[Title]
           ,[Description]
           ,[Owner_UserId])
     VALUES
	 (0, '2014-04-25 20:50:00.000', 'CarWreakly', 'Car Wreakly', 'A blog about cars and everything there of', 1),
	 (0, '2014-04-25 20:50:00.000', 'BouncyBottoms', 'Bouncy Bottoms', 'A blog about bottoms', 2),
	 (0, '2014-04-25 20:50:00.000', 'MVC_Blog', 'MVC Blog', 'Blog about MVC and other .Net releated things', 3)
GO

USE [MVCProjectBlog]
GO

INSERT INTO [dbo].[BlogPost]
           ([Deleted]
		   ,[Created]
           ,[Title]
           ,[PostText]
           ,[BlogPostedIn_BlogId])
     VALUES 
	 (0, '2014-04-23 21:15:12.123', 'My car', 'Crummy text about my car and those things', 1),
	 (0, '2014-04-25 21:15:12.345', 'Car Immagonnabuy', 'Specs of said car and so on', 1),
	 (0, '2014-04-26 21:15:12.345', 'Car I used to own', 'Old said car photos', 1),

	 (0, '2014-04-22 21:15:12.345', 'Booty', 'I Like bottoms', 2),
	 (0, '2014-04-23 21:15:12.345', 'More', 'Just pictures of bottoms or like to aforemention bottoms', 2),
	 (0, '2014-04-25 21:15:12.345', 'MOAR!', '....', 2),

	 (0, '2014-04-21 21:15:12.345', 'MVC', 'MVC things in this post. Andother line of mvc things', 3),
	 (0, '2014-04-23 21:15:12.345', '.NET Rant', 'Blablbalbabllabalblbl .net is fun', 3),
	 (0, '2014-04-25 21:15:12.345', 'C#', 'lambda expressions in particular i find very useful', 3)
GO

USE [MVCProjectBlog]
GO

INSERT INTO [dbo].[BlogRoll]
           ([Deleted]
           ,[Link]
           ,[Blog_BlogId])
     VALUES
	 (0, 'www.carshow.org', 1),
	 (0, 'www.fancycarshow.com', 1),
	 (0, 'www.bigjuice.xxx', 2),
	 (0, 'www.bottoms.org', 2),
	 (0, 'www.msdn.com', 3),
	 (0, 'stackoverflow.com', 3)
GO
USE [MVCProjectBlog]
GO

INSERT INTO [dbo].[BlogComment]
           ([Deleted]
		   ,[Created]
           ,[Email]
           ,[Name]
           ,[Comment]
           ,[BlogPostCommentedOn_BlogPostId])
     VALUES
	 (0, '2014-04-25 20:50:00.000', 'notmyrealemail@emails.co.uk', 'fancypants', 'fince blogpost', 1),
	 (0, '2014-04-25 20:50:00.000', 'asdf@dsokf.com', 'toolsforsale', 'I sell hardware call me at +1 DEALER', 2),
	 (0, '2014-04-25 20:50:00.000', 'inifntepwoer@hotmail.cz', 'kewlguy', 'Nice, i like cars tooo', 3),

	 (0, '2014-04-25 20:50:00.000', 'buts@butsbutsbuts.buts', 'bno', 'Like tem butas', 4),
	 (0, '2014-04-25 20:50:00.000', 'Lord.Darwin@state.gov', 'Charles', 'How did I end up here, Im not good with computers', 5),
	 (0, '2014-04-25 20:50:00.000', 'Jahmal@notthatjahmal.it', 'Jahma', 'Col anothe nigga named jahmal woh like buts. holla', 6),

	 (0, '2014-04-25 20:50:00.000', 'Trace@nico.co.uk', 'Trazzzer', 'Do like them mvc', 7),
	 (0, '2014-04-25 20:50:00.000', 'Rvter@gmailcom', 'Rekt', 'Nice post', 8),
	 (0, '2014-04-25 20:50:00.000', 'Jahmal@notthatjahmal.it', 'Jahma', 'Wow, such nerds. Why dont u post some buts instead?', 7)
GO


